package com.sky.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;
import java.util.Map;

@Mapper
public interface ReportMapper {

    /*
     * 查询某天的营业额数据
     * */
    @Select("select sum(amount) from sky_take_out.orders where order_time between #{begin} and #{end} and status=#{status}")
    Double sumByMap(Map map);
}
